package com.ncloud.system.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.ncloud.system.entity.RegionData;

@Mapper
public interface RegionDataMapper{

	@Select("SELECT id, pid, path, level, name, name_en, name_pinyin, code FROM sys_region_data where pid = #{pid} order by id ")
	@Results({
		@Result(column="id",property="id"),@Result(column="pid",property="pid"),
		@Result(column="path",property="path"),@Result(column="level",property="level"),
		@Result(column="name",property="name"),@Result(column="name_en",property="nameEn"),
		@Result(column="name_pinyin",property="namePinyin"),@Result(column="code",property="code")})
	List<RegionData> getRegionDataInfo(String pid);
}
